<!DOCTYPE HTML>
<html lang="cn" class="light sidebar-visible" dir="ltr">
    <head>
        <!-- Book generated using mdBook -->
        <meta charset="UTF-8">
        <title>Diesel配置 - easy-to-code</title>


        <!-- Custom HTML head -->

        <meta name="description" content="">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <meta name="theme-color" content="#ffffff">

        <link rel="icon" href="favicon.svg">
        <link rel="shortcut icon" href="favicon.png">
        <link rel="stylesheet" href="css/variables.css">
        <link rel="stylesheet" href="css/general.css">
        <link rel="stylesheet" href="css/chrome.css">
        <link rel="stylesheet" href="css/print.css" media="print">

        <!-- Fonts -->
        <link rel="stylesheet" href="FontAwesome/css/font-awesome.css">
        <link rel="stylesheet" href="fonts/fonts.css">

        <!-- Highlight.js Stylesheets -->
        <link rel="stylesheet" id="highlight-css" href="highlight.css">
        <link rel="stylesheet" id="tomorrow-night-css" href="tomorrow-night.css">
        <link rel="stylesheet" id="ayu-highlight-css" href="ayu-highlight.css">

        <!-- Custom theme stylesheets -->


        <!-- Provide site root and default themes to javascript -->
        <script>
            const path_to_root = "";
            const default_light_theme = "light";
            const default_dark_theme = "navy";
        </script>
        <!-- Start loading toc.js asap -->
        <script src="toc.js"></script>
    </head>
    <body>
    <div id="mdbook-help-container">
        <div id="mdbook-help-popup">
            <h2 class="mdbook-help-title">Keyboard shortcuts</h2>
            <div>
                <p>Press <kbd>←</kbd> or <kbd>→</kbd> to navigate between chapters</p>
                <p>Press <kbd>S</kbd> or <kbd>/</kbd> to search in the book</p>
                <p>Press <kbd>?</kbd> to show this help</p>
                <p>Press <kbd>Esc</kbd> to hide this help</p>
            </div>
        </div>
    </div>
    <div id="body-container">
        <!-- Work around some values being stored in localStorage wrapped in quotes -->
        <script>
            try {
                let theme = localStorage.getItem('mdbook-theme');
                let sidebar = localStorage.getItem('mdbook-sidebar');

                if (theme.startsWith('"') && theme.endsWith('"')) {
                    localStorage.setItem('mdbook-theme', theme.slice(1, theme.length - 1));
                }

                if (sidebar.startsWith('"') && sidebar.endsWith('"')) {
                    localStorage.setItem('mdbook-sidebar', sidebar.slice(1, sidebar.length - 1));
                }
            } catch (e) { }
        </script>

        <!-- Set the theme before any content is loaded, prevents flash -->
        <script>
            const default_theme = window.matchMedia("(prefers-color-scheme: dark)").matches ? default_dark_theme : default_light_theme;
            let theme;
            try { theme = localStorage.getItem('mdbook-theme'); } catch(e) { }
            if (theme === null || theme === undefined) { theme = default_theme; }
            const html = document.documentElement;
            html.classList.remove('light')
            html.classList.add(theme);
            html.classList.add("js");
        </script>

        <input type="checkbox" id="sidebar-toggle-anchor" class="hidden">

        <!-- Hide / unhide sidebar before it is displayed -->
        <script>
            let sidebar = null;
            const sidebar_toggle = document.getElementById("sidebar-toggle-anchor");
            if (document.body.clientWidth >= 1080) {
                try { sidebar = localStorage.getItem('mdbook-sidebar'); } catch(e) { }
                sidebar = sidebar || 'visible';
            } else {
                sidebar = 'hidden';
            }
            sidebar_toggle.checked = sidebar === 'visible';
            html.classList.remove('sidebar-visible');
            html.classList.add("sidebar-" + sidebar);
        </script>

        <nav id="sidebar" class="sidebar" aria-label="Table of contents">
            <!-- populated by js -->
            <mdbook-sidebar-scrollbox class="sidebar-scrollbox"></mdbook-sidebar-scrollbox>
            <noscript>
                <iframe class="sidebar-iframe-outer" src="toc.html"></iframe>
            </noscript>
            <div id="sidebar-resize-handle" class="sidebar-resize-handle">
                <div class="sidebar-resize-indicator"></div>
            </div>
        </nav>

        <div id="page-wrapper" class="page-wrapper">

            <div class="page">
                <div id="menu-bar-hover-placeholder"></div>
                <div id="menu-bar" class="menu-bar sticky">
                    <div class="left-buttons">
                        <label id="sidebar-toggle" class="icon-button" for="sidebar-toggle-anchor" title="Toggle Table of Contents" aria-label="Toggle Table of Contents" aria-controls="sidebar">
                            <i class="fa fa-bars"></i>
                        </label>
                        <button id="theme-toggle" class="icon-button" type="button" title="Change theme" aria-label="Change theme" aria-haspopup="true" aria-expanded="false" aria-controls="theme-list">
                            <i class="fa fa-paint-brush"></i>
                        </button>
                        <ul id="theme-list" class="theme-popup" aria-label="Themes" role="menu">
                            <li role="none"><button role="menuitem" class="theme" id="default_theme">Auto</button></li>
                            <li role="none"><button role="menuitem" class="theme" id="light">Light</button></li>
                            <li role="none"><button role="menuitem" class="theme" id="rust">Rust</button></li>
                            <li role="none"><button role="menuitem" class="theme" id="coal">Coal</button></li>
                            <li role="none"><button role="menuitem" class="theme" id="navy">Navy</button></li>
                            <li role="none"><button role="menuitem" class="theme" id="ayu">Ayu</button></li>
                        </ul>
                        <button id="search-toggle" class="icon-button" type="button" title="Search (`/`)" aria-label="Toggle Searchbar" aria-expanded="false" aria-keyshortcuts="/ s" aria-controls="searchbar">
                            <i class="fa fa-search"></i>
                        </button>
                    </div>

                    <h1 class="menu-title">easy-to-code</h1>

                    <div class="right-buttons">
                        <a href="print.html" title="Print this book" aria-label="Print this book">
                            <i id="print-button" class="fa fa-print"></i>
                        </a>

                    </div>
                </div>

                <div id="search-wrapper" class="hidden">
                    <form id="searchbar-outer" class="searchbar-outer">
                        <input type="search" id="searchbar" name="searchbar" placeholder="Search this book ..." aria-controls="searchresults-outer" aria-describedby="searchresults-header">
                    </form>
                    <div id="searchresults-outer" class="searchresults-outer hidden">
                        <div id="searchresults-header" class="searchresults-header"></div>
                        <ul id="searchresults">
                        </ul>
                    </div>
                </div>

                <!-- Apply ARIA attributes after the sidebar and the sidebar toggle button are added to the DOM -->
                <script>
                    document.getElementById('sidebar-toggle').setAttribute('aria-expanded', sidebar === 'visible');
                    document.getElementById('sidebar').setAttribute('aria-hidden', sidebar !== 'visible');
                    Array.from(document.querySelectorAll('#sidebar a')).forEach(function(link) {
                        link.setAttribute('tabIndex', sidebar === 'visible' ? 0 : -1);
                    });
                </script>

                <div id="content" class="content">
                    <main>
                        <h1 id="diesel安装配置运行"><a class="header" href="#diesel安装配置运行">Diesel安装配置运行</a></h1>
<h2 id="官方文档"><a class="header" href="#官方文档">官方文档</a></h2>
<p><a href="https://diesel.rs">https://diesel.rs</a></p>
<p><a href="https://github.com/diesel-rs/diesel">https://github.com/diesel-rs/diesel</a></p>
<h2 id="diesel-cli安装"><a class="header" href="#diesel-cli安装">diesel-cli安装</a></h2>
<h3 id="设置环境变量"><a class="header" href="#设置环境变量">设置环境变量</a></h3>
<ul>
<li>PQ_LIB_DIR</li>
<li>SQLITE3_LIB_DIR</li>
<li>MYSQLCLIENT_LIB_DIR</li>
</ul>
<pre><code>setx PQ_LIB_DIR "C:\Program Files\PostgreSQL\10\lib"

setx SQLITE3_LIB_DIR "C:\SQLite"

setx MYSQLCLIENT_LIB_DIR "C:\Program Files\MySQL\MySQL Connector C 6.1\lib\vs14"
</code></pre>
<h3 id="安装命令"><a class="header" href="#安装命令">安装命令</a></h3>
<pre><code>cargo install diesel_cli --no-default-features --features mysql

cargo install diesel_cli --no-default-features --features sqlite-bundle

cargo install diesel_cli --no-default-features --features postgres
</code></pre>
<h2 id="sqlite"><a class="header" href="#sqlite">sqlite</a></h2>
<h3 id="sqlite源码下载"><a class="header" href="#sqlite源码下载">sqlite源码下载</a></h3>
<p><a href="https://www.sqlite.org/download.html">https://www.sqlite.org/download.html</a></p>
<p>Precompiled Binaries for Windows</p>
<p>[sqlite-dll-win-x64-3xxxx.zip]       用于编译lib文件</p>
<p>[sqlite-tools-win-x64-3xxxx.zip]   exe可执行文件</p>
<h3 id="编译sqlitelib生成lib文件需使用msvc编译器"><a class="header" href="#编译sqlitelib生成lib文件需使用msvc编译器">编译sqlitelib，生成lib文件（需使用msvc编译器）</a></h3>
<pre><code>//生成64位lib
lib.exe /def:sqlite3.def /machine:x64

//生成32位lib
lib.exe /def:sqlite3.def /machine:x86
</code></pre>
<h3 id="修改rust编译器配置"><a class="header" href="#修改rust编译器配置">修改rust编译器配置</a></h3>
<pre><code>[target.x86_64-pc-windows-msvc]

#启用静态编译，仅限于windows

#C:/Users/Administrator/.cargo/libs存放了sqlitelib文件

rustflags = ["-C", "target-feature=+crt-static","-L","C:/Users/Administrator/.cargo/libs"]

#这里需要配置64位的msvc编译器路径

linker = "C:/Program Files (x86)/Microsoft Visual Studio/2019/Enterprise/VC/Tools/MSVC/14.29.30133/bin/Hostx64/x64/link.exe"
</code></pre>
<h2 id="mysql"><a class="header" href="#mysql">MySQL</a></h2>
<h3 id="mysql下载"><a class="header" href="#mysql下载">MySQL下载</a></h3>
<p><a href="https://dev.mysql.com/downloads/mysql">https://dev.mysql.com/downloads/mysql</a></p>
<h3 id="mysql-connectorc"><a class="header" href="#mysql-connectorc">MySQL Connector/C++</a></h3>
<p><a href="https://downloads.mysql.com/archives/c-cpp">https://downloads.mysql.com/archives/c-cpp</a></p>
<h3 id="mysql-connectorc-1"><a class="header" href="#mysql-connectorc-1">MySQL Connector/C</a></h3>
<p><a href="https://downloads.mysql.com/archives/c-c">https://downloads.mysql.com/archives/c-c</a></p>
<h3 id="安装失败"><a class="header" href="#安装失败">安装失败</a></h3>
<p><a href="https://dev.mysql.com/doc/c-api/8.0/en/c-api-implementations.html">https://dev.mysql.com/doc/c-api/8.0/en/c-api-implementations.html</a></p>
<p><a href="https://downloads.mysql.com/archives/c-cpp/">https://downloads.mysql.com/archives/c-cpp</a></p>
<h2 id="postgressql"><a class="header" href="#postgressql">PostgresSQL</a></h2>
<h3 id="下载"><a class="header" href="#下载">下载</a></h3>
<p>https://www.enterprisedb.com/downloads/postgres-postgresql-downloads</p>
<h2 id="使用方法"><a class="header" href="#使用方法">使用方法</a></h2>
<p>1、生成.env</p>
<pre><code>echo DATABASE_URL=mysql://username:password@localhost/diesel_xx &gt; .env
</code></pre>
<p>2、初始化diesel项目</p>
<pre><code>diesel setup
</code></pre>
<p>3、生成schema文件</p>
<pre><code>diesel print-schema &gt; src/schema.rs
</code></pre>
<p>4、手动写入model信息</p>
<h2 id="参考资料"><a class="header" href="#参考资料">参考资料</a></h2>
<p>https://steemit.com/programming/@mrblueberry/installing-rust-and-diesel-for-rocket-on-windows-10</p>

                    </main>

                    <nav class="nav-wrapper" aria-label="Page navigation">
                        <!-- Mobile navigation buttons -->
                            <a rel="prev" href="Tauri_dev.html" class="mobile-nav-chapters previous" title="Previous chapter" aria-label="Previous chapter" aria-keyshortcuts="Left">
                                <i class="fa fa-angle-left"></i>
                            </a>

                            <a rel="next prefetch" href="Python_dev.html" class="mobile-nav-chapters next" title="Next chapter" aria-label="Next chapter" aria-keyshortcuts="Right">
                                <i class="fa fa-angle-right"></i>
                            </a>

                        <div style="clear: both"></div>
                    </nav>
                </div>
            </div>

            <nav class="nav-wide-wrapper" aria-label="Page navigation">
                    <a rel="prev" href="Tauri_dev.html" class="nav-chapters previous" title="Previous chapter" aria-label="Previous chapter" aria-keyshortcuts="Left">
                        <i class="fa fa-angle-left"></i>
                    </a>

                    <a rel="next prefetch" href="Python_dev.html" class="nav-chapters next" title="Next chapter" aria-label="Next chapter" aria-keyshortcuts="Right">
                        <i class="fa fa-angle-right"></i>
                    </a>
            </nav>

        </div>




        <script>
            window.playground_copyable = true;
        </script>


        <script src="elasticlunr.min.js"></script>
        <script src="mark.min.js"></script>
        <script src="searcher.js"></script>

        <script src="clipboard.min.js"></script>
        <script src="highlight.js"></script>
        <script src="book.js"></script>

        <!-- Custom JS scripts -->


    </div>
    </body>
</html>
